Expiration of Historical Databases
نویسنده
چکیده
We present a technique for automatic expiration of data in a historical data warehouse that preserves answers to a known and fixed set of first-order queries. In addition, we show that for queries with output size bounded by a function of the active data domain size (the number of values that have ever appeared in the warehouse), the size of the portion of the data warehouse history needed to answer the queries is also bounded by a function of the active data domain size and therefore does not depend on the age of the warehouse (the length of the history).
منابع مشابه
Optimal credit period and lot size for deteriorating items with expiration dates under two-level trade credit financing and back order
In a supplier-retailer-buyer supply chain, the supplier frequently offers the retailer a trade credit of periods, and the retailer in turn provides a trade credit of periods to her/his buyer to stimulate sales and reduce inventory. From the seller’s perspective, granting trade credit increases sales and revenue but also increases opportunity cost (i.e., the capital opportunity loss during cre...
متن کاملQuerying Nested Historical Relations in Heterogeneous Databases Environment
We study schema integration problems for consolidating historical information from nested relational databases in heterogeneous databases environment. These nested relations are for supporting complex objects. In heterogeneous databases systems, probabilistic partial values have been used to resolve some schema integration problems. In this paper, we extend the concept of probabilistic partial ...
متن کاملCalendar vs. Weeks to Expiration Livestock Basis Forecasts: Which Is Better? by
The ability to accurately forecast basis is crucial to risk management strategies employed by many agribusiness firms. Previous research has examined how to effectively use basis forecasts and what factors affect basis, but literature focusing on forecasting basis is sparse. This research evaluates the impact of adopting a time-to-expiration approach, as compared to the more common calendar app...
متن کاملInvestigation of the Removal of 2-Nitrophenol Using Continuous Flow MSBR Reactor and Estimated Expiration
In this research, biological removal of phenol and orthonitrophenol (2NP) pollutants from wastewater by continuous moving bed sequencing batch reactor (MSBR) was studied. The experiments were conducted in various operational conditions to find out the optimum level of the significant parameters. Best performance for removal of Phenols was achieved when parameter...
متن کاملComparison between historical population archives and decentralized databases
Differences between large-scale historical population archives and small decentralized databases can be used to improve data quality and record connectedness in both types of databases. A parser is developed to account for differences in syntax and data representation models. A matching procedure is described to discover records from different databases referring to the same historical event. T...
متن کامل